package jdbc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class jdbc {
    public static void main(String[] args) {
        UserInfo userInfo= InputUtil.getInputObject(new UserInfo(),"登录","登录");
        try(Connection connection =DBUtil.getConnection();
        ){
            Statement statement=connection.createStatement();
            String sql="SELECT username,password " +
                    "FROM userinfo " +
                    "WHERE username='"+userInfo.getUsername()+"'"  +
                    " AND password ='"+userInfo.getPassword()+"' ";
            ResultSet rs=statement.executeQuery(sql);
           if(rs.next()){
               System.out.println("登录成功,欢迎你"+rs.getString("nickname"));
           } else {
               System.out.println("登录失败");
           }
       }catch (SQLException e) {
            e.printStackTrace();
        }
    }
}
